﻿CREATE TABLE `{dbprofix}categories` (
  `CategoryID` int(11) NOT NULL auto_increment,
  `Key` varchar(64) NOT NULL,
  `CategoryName` varchar(255) NOT NULL,
  `Description` longtext,
  `LogoUrl` varchar(255) default NULL,
  `CreateDate` datetime default '0000-00-00 00:00:00',
  PRIMARY KEY  (`CategoryID`),
  UNIQUE KEY `{dbprofix}Categories_key_unique` USING BTREE (`Key`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;